UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Z89Tw68zhVk5Sc7v79sW5wArsXiLOpDfZrr7g3c0C3w=' 
WHERE 
  key_id = '79808a3522db9d9a8cfbf3f5847200805aabac95c5b54c9daea2c47f7bb1144c' 
  AND (
    token = 'Z89Tw68zhVk5Sc7v79sW5wArsXiLOpDfZrr7g3c0C3w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034