UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mtiCjOjqpcIcBfxUdPTgHn7pSI6gxDJmynlQGRUhCSY='
WHERE
key_id = '0e59e70aaa20c7b14979d1cb1b977274c1ddf58623f9c90daf4e8197201812ac'
AND (
token = 'mtiCjOjqpcIcBfxUdPTgHn7pSI6gxDJmynlQGRUhCSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)