UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Chh7Yn8x3iRXd2ibXrzUdunIZ3bs7g+EZrTQ7csq+YY=' 
WHERE 
  key_id = '18a1b925dfe67f75b380d2e47978737d00e04c2599bc453493797ad78ecd54ea' 
  AND (
    token = 'Chh7Yn8x3iRXd2ibXrzUdunIZ3bs7g+EZrTQ7csq+YY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00056