UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd7tCYnX2BndseFND5muE5gDq8HfCpbAceR4EcNlveHI='
WHERE
key_id = '1d6e01d78cb0569bced7c3ac13ed1d726ff0a10a8f72015d6dcb27ce5f2b7850'
AND (
token = 'd7tCYnX2BndseFND5muE5gDq8HfCpbAceR4EcNlveHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)