UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f5pIEDsKeyEIobaNDX3w419o6xClXDOHKa2hWJrU5Ug='
WHERE
key_id = '57e53710184b973117b26483f5360ae8ab25b378d4992f0e009cd50e48f44d9a'
AND (
token = 'f5pIEDsKeyEIobaNDX3w419o6xClXDOHKa2hWJrU5Ug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)