UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNAkY73d1zRWCjUOcU75T83ZEVh4/6AbcS2iCnrWnsQ='
WHERE
key_id = '8677d05cb30646d6de2dd95d28c7cb9f735f101a36f83715e1784ad91fc9da54'
AND (
token = 'ZNAkY73d1zRWCjUOcU75T83ZEVh4/6AbcS2iCnrWnsQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)