UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gK3Ya0etPCONEhN3xnhazNKkfcVzwuiw5uCso6SDBcA='
WHERE
key_id = '12d2f91141862af9beecd22a1c3754c27ebdc6b7b3968df79cb07d507418ac60'
AND (
token = 'gK3Ya0etPCONEhN3xnhazNKkfcVzwuiw5uCso6SDBcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)