UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TpWdBWj9m8QU9jAUfUXOBvryee6qXD6Dg+xp7KZdF3I='
WHERE
key_id = 'd8e39da74e64f962e428642b635c3dd5fc9448a6a387ae7e509d50096ffdc2ee'
AND (
token = 'TpWdBWj9m8QU9jAUfUXOBvryee6qXD6Dg+xp7KZdF3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)