UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WarF0z06E6xAcCyoAsKyLMGBmlZtijFbN8awrAnXi4k='
WHERE
key_id = 'aa4bee1cda213d8f78f29c96fbd4fd085e8147db699b1f473bbee6801d5e5f97'
AND (
token = 'WarF0z06E6xAcCyoAsKyLMGBmlZtijFbN8awrAnXi4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)