UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YG3yRPd9T1MqvXJ6uEHBKchAI4+C+v5r3LIFVga2reE='
WHERE
key_id = 'c13747a4bcdb7e08a8633e4c3caaecce867da639c780c776150760ce283f9c7f'
AND (
token = 'YG3yRPd9T1MqvXJ6uEHBKchAI4+C+v5r3LIFVga2reE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)