UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jDC2Eb5vXxKWwb5eaLVbjAhjfISZjuWyO4eGogF0whM='
WHERE
key_id = '1fcd1da533b5d2602120e81f6892fc4b2345db729b60c269a55650785a81794d'
AND (
token = 'jDC2Eb5vXxKWwb5eaLVbjAhjfISZjuWyO4eGogF0whM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)