UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CVVCrK1RjHA3C1V3gfmHJxwprebztafpvDEuiH/bq50='
WHERE
key_id = 'b83da837f95c254d33a8107c9e42851e0fe0828db451e0922e14e9c1fec54381'
AND (
token = 'CVVCrK1RjHA3C1V3gfmHJxwprebztafpvDEuiH/bq50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)