UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xGUy8KrH/0V2D+ALVR8epCedMJJdRr6i06WFa0tqlWs='
WHERE
key_id = 'ca1d1657485cdf2a3f7238482f7b00dbe82813a93f13613d4413656702c7244d'
AND (
token = 'xGUy8KrH/0V2D+ALVR8epCedMJJdRr6i06WFa0tqlWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)