UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rB0VMBJiPi+x3yLHU7NCHpFm3W4itUsjB/xpCJpn0F4=' 
WHERE 
  key_id = 'a3bf094af7fc4cebfbd06ab528a3846891afe526ebd2cc2ea28feaf129cb8617' 
  AND (
    token = 'rB0VMBJiPi+x3yLHU7NCHpFm3W4itUsjB/xpCJpn0F4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047