UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dgBcH+mjhjrk7qfGl2UJq4xq44AbAELPPdFa8flKfwY='
WHERE
key_id = '684cc52724f8ff0148904d08289433990703f9127a958e298f535de34e5b4a6f'
AND (
token = 'dgBcH+mjhjrk7qfGl2UJq4xq44AbAELPPdFa8flKfwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)