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