UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3i5twIfLfmSfwF8bSD6IV8VZx62CgWcHbW8weEJ1ssM='
WHERE
key_id = 'ff22b0b6ac77aeca243518a1f6c46275e062a291b1aeef1261a29f9acf192c01'
AND (
token = '3i5twIfLfmSfwF8bSD6IV8VZx62CgWcHbW8weEJ1ssM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)