UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gi0ER4HaFZVruDNWMXiTqX6MGhjczpQOOYIZtVBmj4s='
WHERE
key_id = '06ffbc030a824d226bf4312290560a0f87aca2b8ce1e99ae4f78c6ed090045c3'
AND (
token = 'Gi0ER4HaFZVruDNWMXiTqX6MGhjczpQOOYIZtVBmj4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)