UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JKiNjycVDYSTc6f7vx/b8p+WZOUauS1zcsI9tn1CfwI='
WHERE
key_id = 'eb507494542bc576cc31da30b03d4876aab999b2fed353641949e2a6db3a129d'
AND (
token = 'JKiNjycVDYSTc6f7vx/b8p+WZOUauS1zcsI9tn1CfwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)