UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tuFPdiDR78NiIVgL4n36mTnNp6sg0YPQUzsXg/w8A+M=' 
WHERE 
  key_id = 'b53196e4af50322d6b5b0ff821c2725e9df6435cc9c0fb4df94ba8a66cab5243' 
  AND (
    token = 'tuFPdiDR78NiIVgL4n36mTnNp6sg0YPQUzsXg/w8A+M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021