UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4hVjAqg2pmWkQYjlxc8Ka8fh31I7mwFtDb0+5eIsa2M='
WHERE
key_id = '865e7c9c6a9f36b6b213e9cd6c3b464924d88883eef258ab81da28a2021470d6'
AND (
token = '4hVjAqg2pmWkQYjlxc8Ka8fh31I7mwFtDb0+5eIsa2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)