UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CK7ioUyJmtatWkhfEA/shjFH02Vjglqo6zIE5aNaLvo='
WHERE
key_id = '25ef18bb0d024e7c4db009e1e6002ed3ef31273923474b5dbf95c9f68be848ee'
AND (
token = 'CK7ioUyJmtatWkhfEA/shjFH02Vjglqo6zIE5aNaLvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)