UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DcJYzhwQV6S7A1TYf7j4tEEStelnjAtQfzFl0TR0VD0='
WHERE
key_id = '97321c2642be45f4b64b1447980b3cdd356748d5a26f95fd1d0decce84f74404'
AND (
token = 'DcJYzhwQV6S7A1TYf7j4tEEStelnjAtQfzFl0TR0VD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)