UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHoLZpYc4CwZTJ4zycKMJ+6yupn4Nm34xScp+7nrzTQ='
WHERE
key_id = '024c9bfdfc8fb5207382838e810a41428186ed5e79bc0f57c768774602f72294'
AND (
token = 'xHoLZpYc4CwZTJ4zycKMJ+6yupn4Nm34xScp+7nrzTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)