UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5ZfT52y8kKN/Bkz4Tg9S8tCK16j003MPeNfBeLLroiE=' 
WHERE 
  key_id = 'b1c77e429850d9cd6109f508b23e54d5ad8653677281a54769344c6b294f0b42' 
  AND (
    token = '5ZfT52y8kKN/Bkz4Tg9S8tCK16j003MPeNfBeLLroiE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045