UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JCGYqoHTS3k/kwqmPPhwMhMhLmsxm7CLIsOrZO8rY0M='
WHERE
key_id = 'bc828193d8c5bbd27f090ba9495fa3f4dbf5a6bb955eea7c8df05c82568de872'
AND (
token = 'JCGYqoHTS3k/kwqmPPhwMhMhLmsxm7CLIsOrZO8rY0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)