UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'l0/mAI7SF1ZHDbUY2bbVlJP8dnGh5Xajvmlmupuj/Rc=' 
WHERE 
  key_id = '0f21604c4debc811b81dea6b724f9e18dc08e9652d7264d1a669409a9c881a5f' 
  AND (
    token = 'l0/mAI7SF1ZHDbUY2bbVlJP8dnGh5Xajvmlmupuj/Rc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033