UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8mfQ6aOrjlBKFI/Ii7kUOQ0QjOO41M4cdjnc+IfbW4='
WHERE
key_id = '47e39d4b18a744a0de567b35743346b07977331a138e5446e94b31a8d05ddd2f'
AND (
token = 'G8mfQ6aOrjlBKFI/Ii7kUOQ0QjOO41M4cdjnc+IfbW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)