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