UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZY8CuLfL2Cr4h+ADZ+yNqoan76hVelIr808dJjrkTk='
WHERE
key_id = '9584921196987d6df4bd71f5b414fcb016ae3352caddf84df02c4ecf2a42458d'
AND (
token = '8ZY8CuLfL2Cr4h+ADZ+yNqoan76hVelIr808dJjrkTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)