UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GKcDyrnQ0G1N2unZxUEnw151zc7yLJ64YVfgwg5RBE4='
WHERE
key_id = 'c8ddd8e9f54d2689b236c5c9b9c56bb46efc4d7dda60ea3363ca8b31bf4e89c5'
AND (
token = 'GKcDyrnQ0G1N2unZxUEnw151zc7yLJ64YVfgwg5RBE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)