UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'anEiiBn47BqZ8ZGh+7KROu70h3QIk12neWLruo2Pvso='
WHERE
key_id = 'df7ea8dfb75cd3357a3f66efcd63f61dd411e2c71a58f3f5eff546b9476f39da'
AND (
token = 'anEiiBn47BqZ8ZGh+7KROu70h3QIk12neWLruo2Pvso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)