UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4MqOeJpakRkXyjc7hp5prd8hnaQfUqY317t5CdD4gE='
WHERE
key_id = '48562c8cd5c5bd1115bdc5fea551b4d8e301f30b544fc2d44647faac6ccd93cf'
AND (
token = 'D4MqOeJpakRkXyjc7hp5prd8hnaQfUqY317t5CdD4gE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)